<?php
$SQL[] = "CREATE TABLE market_plugins (
  link varchar(255) NOT NULL default '',
  name varchar(255) NOT NULL default '',
  filename varchar(255) NOT NULL default '',
  position mediumint(8) NOT NULL default '0',
  plugin_config text NOT NULL,
  view_permission mediumtext NOT NULL,
  use_permission mediumtext NOT NULL,
  PRIMARY KEY  (link)
);";

$SQL[] = "CREATE TABLE market_fee_logs (
  l_id int(10) NOT NULL auto_increment,
  member_id mediumint(8) NOT NULL default '0',
  l_time int(10) NOT NULL default '0',
  location varchar(255) NOT NULL default '',
  l_amount int(10) NOT NULL default '0',
  PRIMARY KEY  (l_id),
  KEY member_id (member_id)
);";

$SQL[] = "CREATE TABLE market_reward_logs (
  l_id int(10) NOT NULL auto_increment,
  member_id mediumint(8) NOT NULL default '0',
  l_time int(10) NOT NULL default '0',
  location varchar(255) NOT NULL default '',
  l_amount int(10) NOT NULL default '0',
  PRIMARY KEY  (l_id)
);";

$SQL[] = "ALTER TABLE market_items ADD allow_resell tinyint(1) NOT NULL DEFAULT '0'";
?>